Skip Headers

Oracle Procedural Gateway® for APPC User's Guide 10g Release 2 (10.2) for Microsoft Windows (32-Bit) Part Number B16212-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P R S T U V W X

## A

  APPC
    runtime, 4.10.2
    SENDs and RECEIVEs
      TIP CALL correspondence, 4.6.2
    trace, 8.9.2.1, 8.9.2.2
    using with terminal-oriented transaction program, 4.12
  APPC conversation sharing, 4.10
    concepts, 4.10.1
    examples, 4.10.5
    for too large TIPs, 4.10.4
    overrides and diagnostics, 4.10.6
    TIP compatibility, 4.10.3
    usage, 4.10.2
  architecture
    commit-confirm, 5.5
    components of the gateway, 1.5
  ASCII
    automatic conversion, 1.2

## B

  BIT_AND function, C.1.1
  BIT_COMPLEMENT function, C.1.2
  BIT_OR function, C.1.3
  BIT_XOR function, C.1.4

## C

  CALL correspondence
    on gateway using SNA, 4.6.2
    on gateway using TCP/IP, 7.3.2
  call correspondence order restrictions
    on gateway using SNA, 4.6.2.2
    on gateway using TCP/IP, 7.3.2.2
  CAST_TO_RAW function, C.1.5
  CAST_TO_VARCHAR2 function, C.1.6
  CICS, 1.9.1
  CICS Transaction Server
    gateway starts communication with, 1.10.1
  client application development
    calling a TIP
      on gateway using SNA, 4.7
      on gateway using TCP/IP, 7.4
    customized TIPs for remote host transaction, 4.4
    declaring TIP variables, 4.7.1, 7.4.1
    error handling
      on gateway using SNA, 4.8.2
      on gateway using TCP/IP, 7.5.2
    examples and samples, 1.4
    exchanging data, 4.8
      on gateway using TCP/IP, 7.5
    executing, 4.9, 7.7
    granting execute authority, 4.8.3, 7.5.3
    on gateway using TCP/IP, 7
    overriding TIP initializations, 4.7.2.2
      on gateway using TCP/IP, 7.4.2.2
    overview, 4.1
    preparation, 4.2
    remote host transaction types
      multi-conversational transactions, 4.3.2.3
      one-shot transactions, 4.3.2.1
      persistent transactions, 4.3.2.2
      See also, index entries for each transaction type
    requirements, 4.5
      declare RHT/TIP data to be exchanged, 4.5, 4.5, 4.5
      exchange data with RHT using TIP user function, 4.5, 4.5
      initialize RHT for multi-conversational applications, 4.5
      initialize RHT using TIP initialization function, 4.5, 4.5
      repetitively exchange data with RHT using TIP user function, 4.5
      terminate RHT using TIP termination function, 4.5, 4.5, 4.5
    security considerations, 4.7.2.3, 7.4.2.3
    terminating the conversation, 4.8.1, 7.5.1
    TIP and remote transaction program correspondence, 4.6, 7.3
    TIP CALL correspondence, 4.6.2
    TIP content and purpose, 4.3.1
    TIP DATA correspondence, 4.6.1, 7.3.1
    TIP TRANSACTION correspondence
      on gateway using SNA, 4.6.3
      on gateway using TCP/IP, 7.3.3
  client application development for gateway using TCP/IP
    overview, 7.1
  client application development on gateway using TCP/IP
    preparing, 7.2
  COBOL, 4.2, 7.2, D.2, D.2.4
    datatype conversion supported by PG DD and TIPs, D.2
    lacks datatype for variable length data, D.2.1
    PGAU interpretation of COBOL symbols, D.2.1
    support for double byte character sets, PIC G datatypes, 4.11, 7.8
  COMMIT command, 2.2.1, 2.2.2
    user responsibility, 2.2.1
  COMMIT processing, 2.2.1
  commit-confirm, 5.1
    application design requirements, 5.4
    architecture, 5.5
      components, 5.5.1
      interactions, 5.5.2
    components, 5.3
    logic flow, 5.6
      step by step, 5.6.1
    Oracle Global Transaction ID, 5.1
    purpose, 5
    relation to two-phase commit, 5.1
    required components
      OLTP commit-confirm transaction log, 5.3
      OLTP forget/recovery transaction, 5.3
      OLTP transaction logging code, 5.3
      Oracle logging server, 5.3
    supported OLTPs, 5.2
    transaction log, 5.6.2
  communication
    between mainframe and Oracle Integrating Server
      on gateway using SNA, 1.10
    between server, gateway and remote host, 1.7
  COMPARE function, C.1.7
  compiling a TIP, 3.4
  CONCAT function, C.1.8
  CONNECT command, 2.3, 2.6.1
  control file
    creating
      on gateway using SNA, 1.11.1
      on gateway using TCP/IP, 1.14.1
  conversation sharing, see APPC conversation sharing
  CONVERT function, C.1.9
  COPIES function, C.1.10
  creating a TIP
    (detailed), 3
    overview, 1.11, 1.14

## D

  data conversion
    errors, 8.4
    languages supported, E.3
  DATA correspondence, 4.6.1, 7.3.1
  data dictionary, see PG DD
  data exchange
    PGAXFER function, 1.8.1.2
  data format conversion, D
  database instance, 1.6
  database link, 1.7
  datastores
    gateway access to, 1.1
  datatype
    RAW, C
  datatype conversion, D
    COBOL editing symbols, D.2.1
    convert length, D.1
    duplicate names, D.2.4
    expected length, D.1
    format conversion, D.2.1
    parameters over 32K in length, D.1.1
    PL/SQL, D.2.4
      naming algorithms, D.2.4
    receive length, D.1
    removing support for parameters over 32K in length, D.1.1
    See USAGE (PASS), USAGE (ASIS). USAGE (SKIP), and PL/SQL Naming Algorithms
    send length, D.1
    truncated and non-unique names, D.2.4
  datatype conversions
    COBOL symbols interpreted by PGAU, D.2.1
  datatypes
    See PIC X and PIC G
  DBCS
    See double-byte character sets
  DBMS_PIPE PL/SQL package, 3.1
  debugging tool
    PGATRAC function, B.1.5
  DEFINE CALL, 2.1
  DEFINE CALL parameters, 2.6.2
  DEFINE CALL statement ("command"), 1.11.1, 3.2.6, 4.10.4, G.2
  DEFINE DATA, 2.1
  DEFINE DATA statement ("command"), 1.11.1, 2.6.15, 3.2.6, 4.6.1, 4.10.4, 7.3.1, A.2.3.7, G.1
  DEFINE TRANSACTION parameters, 2.6.4
  DEFINE TRANSACTION statement ("command"), 3.2.6, 4.10.4, G.3
  defining and generating a TIP, 3.3
  definition versioning, 2.5.2
  deleting and inserting rows into PGA_TCP_IMSC table, 6.5
  DESCRIBE command, 2.6.5
  DISCONNECT command, 2.6.6
  double byte character sets (DBCS)
    in application development, 4.11, 7.8
  driver procedure
    on gateway using SNA, 1.11.1
    on gateway using TCP/IP, 1.14.1

## E

  EBCDIC
    automatic conversion, 1.2
  environment dictionary
    sequence numbers, A.1.1
  errors
    causes of, 8.1
    data conversion, 8.4
    including exception handlers in your TIP, 4.8.2, 7.5.2
    NUMBER_TO_RAW function, C.2.3
    PLS -00123
      program too large, 4.10.4
    truncation, 8.5
  examples
    APPC conversation sharing, 4.10.5
  EXECUTE command, 2.6.7
  executing
    client application development, 4.9, 7.7
  EXIT command, 2.6.8

## F

  file
    initsid.ora, 1.3, 8.9.1, 8.9.1, 8.9.2, 8.9.2.1, E.2, E.2, E.2
    pagaims, F
    pgadb2i, F
    pgadb2id.sql, 4.8.2
    pgadb2i.pkb, 1.4, 1.11.1, 4.1, 4.3.1
    pgadb2i.pkh, 1.4, 1.11.1, 1.11.1, 4.3.1
    pgadb2i.sql, F
    pgau.trc, 2.6.9, 2.6.9
    pgddausr.sql, 4.13, 7.9
    pgddcr8.sql, 2.5.2, A.2
    pgtflipd.sql, 7.5.2, F
    pgtflip.pkb, 1.14.1, 7.1, 7.2.1
    pgtflip.pkh, 1.14.1, 7.2.1
    tipname.doc, 3.5, 4.5, 4.7.1, 7.4.1
    tipname.pkb, 8.6
    tname.ctl, 3.2.7, 3.2.7
  flexible call sequence
    on gateway using SNA, 4.6.2.1
    on gateway using TCP/IP, 7.3.2.1
  FLIP
    and pgacics PL/SQL stored procedure
      on gateway using SNA, 1.10.1
    transaction in CICS, 1.10
    transaction in IMS, 1.13
  format conversion, D.2.1
  function
    PGATERM, B.1.3
    PGAXFER, 4.3.1, 7.2.1, B.1.2
    UTL_PG, C.2
    UTL_RAW, C.1
  functions
    see RPC (remote procedural call)
    See UTL_PG
    see UTL_PG
    See UTL_RAW, C.1
    see UTL_RAW

## G

  gateway
    access to IBM datastores, 1.1
    communication, 1.1
      overview, 1.7
      with CICS in mainframe on gateway using SNA, 1.10.1
    components, 1.5
    creating a TIP, 3
    enabling a trace, 8.9.2.2
    features
      application transparency, 1.2
      code generator, 1.2
      fast interface, 1.2
      flexible interface, 1.2
      location transparency, 1.2
      Oracle server integration, 1.2
      performs automatic conversions, 1.2
      site autonomy and security, 1.2
      support for tools, 1.2
    function, 1
    initialization files, 1.3
    language support, E.2
    overview, 1.1
      using TCP/IP, 1.1
    remote procedure, definition, 1.3
    remote transaction initiation
      using SNA, 1.8.1.1
      using TCP/IP, 1.8.1.1
    remote transaction termination
      using SNA, 1.8.1.3
      using TCP/IP, 1.8.1.3
    server trace output sample, 8.10
    starting, 1.6, 1.6
    tracing, 8.9
    transaction types
      on gateway using SNA, 1.9.1
      on gateway using TCP/IP, 1.12.1
  gateway sample files
    using SNA
      pgadb2i.pkb, 1.4
      pgadb2i.pkh, 1.4
    using TCP/IP
      pgadb2i.pkb, 1.4
      pgadb2i.pkh, 1.4
  gateway server, 5.5.1
    function in commit-confirm architecture, 5.5.1
    transaction log tables, 5.6.2
  gateway server trace, 8.9, 8.9.2
    output sample, 8.10
  GENERATE, 2.1
  GENERATE statement ("command"), 1.11.1, 3.2.6, 3.3, 4.6.1, 7.3.1, F.2, G.4
  GLOBAL_TRAN_ID, 5.6.2
  granting privileges for creating TIPs, 3.1
  GROUP statement (PGAU), 3.3

## H

  HOST command, 2.6.11

## I

  implicit APPC, 4.12
  implicit versioning
    sample definitions, G.5
  IMS, 1.1
    communication with Integrating Server
      using TCP/IP, 1.13.2
  IMS inquiry
    location of sample file, 1.4
  IMS/TM
    communication through the gateway, 1
  initialization files
    see gateway initialization files, also see PGA parameters
  initiating remote transactions, 1.8.1.1, 1.8.1.1
  initsid.ora file, 1.3, 8.9.1, 8.9.1, 8.9.2, 8.9.2.1, E.2, E.2, E.2
    parameters to run pg4tcpmap tool, 6.4
  I/O PCB, 1.13, 3.2.1, 7.1

## J

  JUSTIFIED, D.2.1
  JUSTIFIED LEFT, D.2.1
  JUSTIFIED RIGHT, D.2.1

## K

  keywords
    PGAU, 2.5.3

## L

  LANGUAGE parameter
  LENGTH function, C.1.11
  LENGTH IS field-2, D.2.1
  LU_NAME, 5.6.2

## M

  MAKE_NUMBER_TO_RAW_FORMAT function, C.2.5
  MAKE_RAW_TO_NUMBER_FORMAT function, C.2.4
  mapping parameters
    from SNA to TCP/IP, 6.1
  mapping table
    PGA_TCP_IMSC, 1.13.2
  MBCS, See multi-byte character sets
  messages
    UTL_RAW interface, C.1
  MODE_NAME, 5.6.2
  multi-byte character sets (MBCS), 4.11, 7.8
    application development support, 4.11, 7.8
  multi-conversational transaction type
    for gateway using SNA, 1.9.1
  multi-conversational transactions, 4.3.2.3, 4.5

## N

  National Language Support (NLS), 3.2.4, E, E.3
    in the gateway, E.2
    languages supported for data conversion, E.3
    multi-byte character set support, 4.11, 7.8
  NLS LANGUAGE parameter
    syntax, E.2
  non-persistent socket transaction type for TCP/IP for IMS Connect, 1.12.1
  NUMBER_TO_RAW and RAW_TO_NUMBER argument values, C.3, C.3, C.3
  NUMBER_TO_RAW function, C.2.3
    errors, C.2.3
  NUMBER_TO_RAW_FORMAT function, C.2.7

## O

  OCCURS DEPENDING ON, D.2.1
  OCCURS n TIMES, D.2.1
  OLTP
    and TCP/IP, 1.3, 1.5
    character set, E.3
    commit-confirm transaction log, 5.3
    definition, 1.3
    forget/recovery transaction, 5.3
    functional requirements of the gateway, 5.4
    in commit-confirm, 5.1
    in gateway architecture featuring SNA, 1.5
    in gateway using TCP/IP, 1.5
    logic flow for successful commit, 5.6
    only IMS supported on gateway using TCP/IP, 1.2, 1.3
    parameters needed for NLS, E.3
    remote, 1
    security considerations, 4.7.2.3, 7.4.2.3
    transaction logging code, 5.3
  one-shot transaction types, 1.9.1, 4.3.2.1, 4.5, 5.4
  online transaction processor
    See OLTP
  operating system
    role in gateway installation, 1.5
  Oracle global transaction ID, 5.1, 5.1, 5.3, 5.4, 5.6.2
  Oracle integrating server, 1.8.1.2, 4.1
    and role in client application, on gateway using TCP/IP, 7.1
    calling RPC functions, 5.5.2
    component of commit-confirm architecture, 5.5.1
    component of the gateway, 1.5
    definition, 1.3
    function in gateway communication
      on gateway using TCP/IP, 1.13
    interaction with gateway server in commit-confirm, 5.5.2
    multiple servers on the gateway
      using SNA, 1.5
      using TPC/IP, 1.5
    precompiles PL/SQL package, 1.2
    role
      in gateway communication, 1.7
      in starting the gateway, 1.6
    simple communication
      on gateway using SNA, 1.10
      on gateway using TCP/IP, 1.13, 1.13
    steps to communication
      between server and IMS, 1.13.2
      between server and mainframe, 1.10.1
    stores PL/SQL, 1.3
    support for NLS, E.3
  Oracle logging server, 5.3, 5.5.1, 5.5.2
    description, 5.5.1
    interaction with gateway server, 5.5.2
  Oracle Net, 1.3, 4.13, 7.9, C, C
    restrictions for data conversion, C
  Oracle Procedural Gateway for APPC
    also see gateway
    compatibility with version 3.4.0, 4.10.3
    development environment, 1.2
    See also, gateway server
  OVERLAY function, C.1.12
  overrides, 4.7.2.2, 7.4.2.2
    LOGMODE, 4.7.2.2, 7.4.2.2
    LUname, 4.7.2.2, 7.4.2.2
    Side profile, 4.7.2.2, 7.4.2.2
    TPname, 4.7.2.2, 7.4.2.2

## P

  package
    UTL_PG, 3.1
  parameters
    mapped to TPC/IP, 6.3
    See NLS LANGUAGE
    see PGAU commands
    See remote procedural call (RPC)
    See SET LOG_DESTINATION
    See SET TRACE_LEVEL
  persistent socket transaction type
    for TCP/IP for IMS Connect, 1.12.1
  persistent transaction type, for gateway using SNA, 1.9.1
  persistent transactions, 4.3.2.2, 4.5, 4.5, 5.4
  PG DD (Data Dictionary), 2.1, 2.6.4
    active dictionary, A.2
      sequence numbers, A.2.2
      versioning, A.2.1
    active dictionary tables
      pga_call, A.2.3.5
      pga_call_parm, A.2.3.6
      pga_data, A.2.3.7
      pga_data_attr, A.2.3.9
      pga_data_values, A.2.3.10
      pga_fields, A.2.3.8
      pga_trans, A.2.3.1
      pga_trans_attr, A.2.3.2
      pga_trans_calls, A.2.3.4
      pga_trans_values, A.2.3.3
    data definitions for parameters over 32K in length, D.1.1
    datatype conversion support for COBOL, D.2
    definition, 1.3
    definition names
      valid characters in, 2.5.1
    diagnostic
      options, 8.2
      references, 8.1
    entries, creating a TIP, 3.3
    environment dictionary tables, A.1, A.1.2, A.1.2.1
      pga_modes, A.1.2.10
      pga_usage, A.1.2.9
    in writing PGAU statements, 3.2.6
    keyword form in storage, 2.5.3
    maintenance, 2.3
    overview, A
    preparing client application
      on gateway using SNA, 4.2
      on gateway using TCP/IP, 7.2
    purpose of REPORT command, 2.6.15
    relationship to PGAU, 2.1
    remote transaction definitions, 2.4
    ROLLBACK command, 2.2.1
    select scripts, 8.3
    storage of information needed for PGAU GENERATE to perform, 4.6.1, 7.3.1
    transaction attributes, 4.7.2.2, 7.4.2.2
    USAGE (SKIP), D.2.3
    version definition tables, 2.5.2
  pg4tcpmap tool, 1.13.2, 3.2.5, 7
    calling, to map DEFINE TRANSACITON parameters, 7.6
    commands to operate PGA_TCP_IMSC table, 6.5
    definition, 1.3
    description and function in the gateway, 1.2
    function, 1.2
      in mapping input parameters, 6.1
    function in remote transaction initiation, 1.8.1.1
    preparation for populating PGA_TCP_IMSC table, 6.1
    setting parameters in initsid.ora, 6.4
    to map SideProfile name, 2.6.4
  PGA
    administrator, 2.1
    definition, 1.3
  pga_call table, A.2.3.5
  pga_call_parm table, A.2.3.6
  PGA_CC_PENDING table
    commit-confirm transaction log, 5.6.2
  pga_compilers table, A.1.2.5
  pga_data table, A.2.3.7
  pga_data_attr, A.2.3.9
  pga_data_values table, A.2.3.10
  pga_datatype_attr table, A.1.2.7
  pga_datatype_values table, A.1.2.8
  pga_datatypes table, A.1.2.6
  pga_env_attr table, A.1.2.3
  pga_env_values table, A.1.2.4, A.1.2.4
  pga_environments table, A.1.2.2
  pga_fields table, A.2.3.8
  pga_maint table, A.1.2.1
  pga_modes constant, A.1.2.10
  PGA_TCP_IMSC table, 1.13.2, 3.2.5, 6.1, 6.2, 7, 7.1, 7.3.3
    content and parameters, 6.3
    querying, 6.5.3
  PGA_TCP_PASS, 6.2
  PGA_TCP_USER, 6.2
  pga_trans table, A.2.3.1
  pga_trans_attr table, A.2.3.2
  pga_trans_calls table, A.2.3.4
  pga_trans_values table, A.2.3.3
  pga_usage, A.1.2.9
  pga_usage constant, A.1.2.9
  PGAADMIN, 3.1
  pgacics.sql, 1.10
  pgadb2i file, F
  pgadb2id.sql file, 4.3.1, 4.8.2
  pgadb2i.pkb, 1.4
  pgadb2i.pkb file, 1.4, 1.11.1, 4.1, 4.3.1
  pgadb2i.pkh file, 1.4, 1.4, 1.11.1, 1.11.1
  pgadb2i.sql file, 4.3.1, F
  pgaims file, F
  pgaims.sql, 1.13
  PGAINIT, 1.8.1.1, B.1.1
    role in mapping SNA parameters to TCP/IP, 6.1
  PGAINIT function, 1.3, 1.8.1.1, 1.8.1.1
  PGATCTL, B.1.4
  PGATERM, B.1.3
  PGATERM function, 1.3, 1.8.1.1
  PGATRAC, B.1.5
  PGAU, 4.1
    accesses definitions in PG DD, 1.3
    commands- also called "statements", 2.6
    COMMIT processing, 2.2.1
    defining and testing a TIP, 2.5
    definition, 2
      used to generate TIP specifications, 1.3
    definition names, 2.5.1
    definition versioning, 2.5.2
    definitions, 2.4
    functions, 2.1
    -generated TIP specifications, 1.7
    generation, 2.4
    interpretation of COBOL symbols in datatype conversion, D.2.1
    invoking, 2.3, 2.3
    keywords, 2.5.3, 2.5.3
    NLS Language usage, E.2
    overview, 2.1
    purpose of PGDL, 1.3
    role in calling TIPs, on gateway using TCP/IP, 7.1
    ROLLBACK processing, 2.2.2
    sample input, G
    writing statements, 3.2.6
  PGAU commands, 1.11.1
    CONNECT, 2.3, 2.6.1
    CONNECT, parameters, 2.6.1
    DEFINE CALL, 2.6.2, 2.6.2, 2.6.15, 3.2.6, 4.10.4
      call list, 3.2.2
      on gateway using SNA, 1.11.1
      sample, G.2
    DEFINE DATA, 2.6.3, 2.6.15, 3.2.6, 4.6.1, 4.10.4, 7.3.1, A.2.3.7
      on gateway using SNA, 1.11.1
      parameters, 2.6.3
      sample, G.1
    DEFINE DATA, datatype conversions
      USAGE (ASIS), D.2.2
      USAGE (PASS), D.2.1
      USAGE (SKIP), D.2.3
    DEFINE PGAU, call list, 3.2.3
    DEFINE TRANSACTION, 1.11.1, 2.1, 2.6.4, 2.6.4, 3.2.6, 4.10.4
      sample, G.3
    DEFINE TRANSACTION, parameters, 2.6.4, 3.2.4, 3.2.4
    defining correlation between TIP and RTP, 2.1
    DESCRIBE, 2.6.5
    DESCRIBE, parameters, 2.6.5
    DISCONNECT, 2.6.6
    DISCONNECT, parameters, 2.6.6
    EXECUTE, 2.6.7
    EXECUTE, parameters, 2.6.7
    EXIT, 2.6.8
    EXIT, parameters, 2.6.8
    formatting of Call and Transaction reports, 2.6.15
    four main types, in control file, 1.11.1
    GENERATE, 2.6.9, 3.2.6, 3.3, 3.5, 4.6.1, 7.3.1, F.2
      error messages, 8.3
      on gateway using SNA, 1.11.1
      parameters, 2.6.9
      problem analysis, 8.2
      sample, G.4
      support and non-support for parameters over 32K length, D.1.1
      traces, 8.1
    GROUP, 2.6.10, 2.6.10, 3.3, 3.3
    HOST, 2.6.11
      parameters, 2.6.11
    on gateway using SNA, 1.11.1
    PRINT, 2.6.12, 2.6.12
    REDEFINE DATA, 2.6.13, 2.6.13, A.2.3.7
      sample, G.6
    REM, 2.6.14
    REM, parameters, 2.6.14
    REPORT, 2.6.15
      output sample, G.8
    REPORT, parameters, 2.6.15
    SET, 2.6.16
    SET, parameters, 2.6.16
    SHOW, 2.6.17
    SHOW, parameters, 2.6.17
    SPOOL, 2.6.18
    SPOOL, parameters, 2.6.18
    TRANSACTION, 2.6.15
    UNDEFINE CALL, 2.6.19
    UNDEFINE CALL, parameters, 2.6.19
    UNDEFINE DATA, 2.6.20
    UNDEFINE DATA, parameters, 2.6.20
    UNDEFINE TRANSACTION, 2.6.21
    UNDEFINE TRANSACTION, parameters, 2.6.21
    UNDEFINE, sample, G.7
    VARIABLE, 2.6.22
    VARIABLE, parameters, 2.6.22
  PGAU script file
    adding spool and echo, 3.3
    creating, 3.2.7
  pgau.trc file, 2.6.9, 2.6.9
  PGAXFER, 7.3.2.2, B.1.2
  PGAXFER function, 1.3, 1.8.1.1, 1.8.1.2, 4.3.1, 7.2.1
  PGDD (Data Dictionary)
    environment sequence numbers, A.1.1
  pgddausr.sql file, 4.13, 7.9
  pgddcr8.sql file, 2.5.2, A.2
  PGDL (Procedural Gateway Definition Language), 2.1, B
    definition, 1.3
  pgtflip, 7.5.3
  pgtflipd, 1.14.1
  pgtflipd.sql, 7.4.1
  pgtflipd.sql file, 7.2.1, 7.5.2, F
  pgtflip.pkb, 1.4, 1.4
  pgtflip.pkb file, 1.14.1, 7.1, 7.2.1
  pgtflip.pkh, 1.4
  pgtflip.pkh file, 1.14.1
  pgtflip.sql file, 7.2.1
  PIC 9, 8.4, D.2.1
  PIC G, 8.4
    datatypes, 4.11, 7.8
  PIC G datatype conversions, D.2.1
  PIC G datatypes, D.2.1
  PIC X, D.2.1
  PIC X datatypes, 8.4, D.2.1
  PKGEX(DC) diagnostic option, 8.6
  PKGEX(DR)
    GENERATE diagnostic option, 8.2
  PL/SQL, 1.3, C.1
    call, A.2.3.4, A.2.3.5
    code, B.1
    code generator, 1.2, 8.4
    data length limits, 8.5
    datatypes, 1.7, 4.5, 4.5, 4.5, 4.6.1, G.4, G.5
      converted to RAW, 1.8.1.2
    developing TIPs, D
    enabling a trace, 8.9.2.2
    function in the gateway, 1.1, 1.7
    invoking PG4APPC, 1.10, 1.13
    naming algorithms, D.2.4
      delimiters, D.2.4
      duplicate names, D.2.4
      qualified compound names, D.2.4
    parameters, 4.7.1, 7.4.1
    record format, G.5
    stored procedure, 1.10.1
    transferring data
      using RAW datatype, C
    UTL_PG package function, 1.3
    UTL_RAW function, 1.3
    variable names, D.2.4
      datatype conversion, D.2.4
    variables, 3.5, D.2.1, D.2.1, D.2.1, D.2.4
  PL/SQL package, 2.3, 2.6.2, 2.6.19, 2.6.21, 3.1, 4.3.1, 8.2, B, F.2, F.2
    components, 4.3.1, 4.3.1, 7.2.1, 7.2.1
    contents
      package specification, 4.3.1, 7.2.1
    DBMS_PIPE, 3.1
    definition, 1.3, 1.3
    execute authority, 4.8.3, 7.5.3
    function, 4.1, 7.1
    functions, 1.7
    grants required, 3.1
    pagcics, 1.10.1
    parameter, 2.6.9
    See TIP
    specifying names, 4.6.3, 7.3.3
  PL/SQL stored procedure, 5.5.2
    changing trace level, B.1.4
    starting up communication with mainframe, 1.10.1, 1.13.2
  PL/SQL stored procedure specification
    also called "TIP"
    See PL/SQL package
  PRINT command, 2.6.12
  privileges
    needed to use TIPs, 4.13
  problem analysis
    of data conversion and truncation errors, 8.5
    with PG DD diagnostic references, 8.2
    with PG DD select scripts, 8.3
    with TIP runtime traces, 8.6
  Procedural Gateway Administration
    see PGA
  Procedural Gateway Administration Utility
    see PGAU, 1.7

## R

  RAW, C.1.8
  RAW_TO_NUMBER FORMAT function, C.2.6
  RAW_TO_NUMBER function, C.2.2
  recompilation errors
    causes, F.2.2.1
  REDEFINE DATA statement, A.2.3.7, G.6
  REDEFINES, D.2.1
  REM command, 2.6.14
  remote host transactions (RHT)
    APPC conversation sharing, 4.10
    attributes needed, 4.6.3, 7.3.3
    client application, 4.5
    defined using the PGAU DEFINE TRANSACTION statement, 4.6.3, 7.3.3
    evaluating, 3.2
    multi-conversational, client applications, 4.5
    one-shot, client applications, 4.5
    persistent, client applications, 4.5
    requirements
      understanding, 4.3
    steps involved in, 4.5
    types
      on gateway using SNA, 1.9.1, 4.3.2
      on gateway using TCP/IP, 7.2.2
  remote procedural call
    See RPC
  remote procedural call (RPC), A.2.3.5
    calling the gateway, B
    executing gateway functions, B.1
    parameters, B.1.4
    PGAINIT and PGAINIT_SEC, B.1.1
    PGAINIT and PGAINIT_SEC, parameters, B.1.1
    PGATCTL, B.1.4
    PGATERM, B.1.3
    PGATERM, parameters, B.1.3
    PGATRAC, B.1.5
    PGATRAC, parameters, B.1.5
    PGAXFER, B.1.2
    PGAXFER, parameters, B.1.2
  remote procedure
    definition, 1.3
  remote transaction initiation
    on gateway using SNA, 1.8.1.1
    on gateway using TC/IP, 1.8.1.1
  remote transaction program
    See RTP
  remote transaction termination
    on gateway using SNA, 1.8.1.3
    on gateway using TCP/IP, 1.8.1.3
  RENAMES, D.2.1
  REPORT statement, 3.2.6
  REVERSE function, C.1.13
  RHT, See remote host transactions
  ROLLBACK command, 2.2.1, 2.2.2
  ROLLBACK processing, 2.2.2
  RPC
    definition, 1.3
    function
      PGAINIT, 1.3, 1.8.1.1, 1.8.1.1
      PGATERM, 1.3
      PGAXFER, 1.3, 1.8.1.2
      within the gateway, 1.1, 1.8
    processing, 1
  RPC interface
    PGATCTL, B.1.4
    PGATERM, B.1.3
    PGATRAC, B.1.5
    PGAXFER, B.1.2
    See also, remote procedural call (RPC)
  RTP
    activities, 4.3.2.2
    definition, 1.3
    executing, 1.3
    function in the gateway, 1.1
    on gateway using SNA, 4.4
    purpose, 4.3.1, 7.2.1
  runtime traces, 8.6
    controls, 8.7
    conversion warnings, 8.7.2
    data conversion tracing, 8.7.4
    gateway exchange tracing, 8.7.5
    runtime function entry/exit tracing, 8.7.3

## S

  sample
    PGAU DEFINE CALL command, G.2
    PGAU DEFINE DATA command, G.1
    PGAU DEFINE TRANSACTION command, G.3
    PGAU GENERATE command, G.4
    PGAU REDEFINE DATA command, G.6
    PGAU REPORT output, G.8
    PGAU UNDEFINE command, G.7
    TIP output, G.11
    TIP trace output, G.10
  sample definitions
    implicit versioning, G.5
  script file, 3.2.7
  sequence objects
    in the PGDD environment dictionary, A.1.1
  SET command, 2.6.16
  SET LOG_DESTINATION parameter, 8.5, 8.5, 8.9.1, 8.9.1
  SET TRACE_LEVEL parameter, 8.5, 8.9.1, 8.9.2.1, 8.9.2.2
  Side Information Profile, 2.6.4, B.1.1
  SIDE_NAME, 5.6.2
  SIDEPROFILE (name), 2.6.4
  simple PG4APPC communication
    on gateway using SNA, 1.10
  SNA
    and gateway components, 1.5
    communication between mainframe and Oracle Integrating Server, 1.10
    communications function, 1.10
    creating a TIP, 1.11
    determining validity of TIP specification, F.2.1.1
    examples and sample files used in this guide, 1.4
    flexible call sequence, 4.6.2.1
    function in the gateway, 1.1
    gateway transaction types, 1.9.1
    implementing commit-confirm, 5
    overview of the gateway, using, 1.1
    parameters, 1.8.1.1
    PGAU DEFINE TRANSACTION command, 3.2.4
    remote transaction initiation, 1.8.1.1, 1.8.1.1
    remote transaction termination on the gateway, 1.8.1.3
    steps to connecting Integrating Server and mainframe, 1.10.1
    supported remote host languages, 3.2.1
    TIP internals, F
    trace output files, 8.10.1
    uses APPC to access all systems, 1.1
    writing TIPs, 1.11
  socket file descriptor
    returned by TCP/IP network to PGAINIT, 1.8.1.1
  specification file
    on gateway using SNA, 1.11.1
    on gateway using TCP/IP, 1.14.1
  SPOOL command, 2.6.18
  SQL*Plus
    connecting server and mainframe, 1.10.1
    invoking, 3.4
    recompiling TIP body changes, F.2.1
    running scripts, 4.13, 7.9
    test scripts, 8.3
  starting
    the gateway, 1.6
  starting the gateway, 1.6
  statements
    see PGAU commands
  SUBSTR function, C.1.14
  supported languages, E.2
  SYNCHRONIZED, D.2.1
  SYNCHRONIZED LEFT, D.2.1
  SYNCHRONIZED RIGHT, D.2.1

## T

  TCP/IP for IMS Connect, 1.13, 7.4.2.1
    and gateway components, 1.5
    and PGA_TCP_IMSC parameter table, 6.2
    and PGAINIT, 6.1
    and Remote Transaction Initiation, 1.8.1.1
    Client application overview, 7.1
    communication between gateway and OIS, 1.13
    content of PGA_TCP_IMSC table, 6.3
    creating a TIP, 7
    determining validity of TIP specification, F.2.1.1
    elements of TIP-RTP correspondence, 7.3
    examples and sample files used in this guide, 1.4
    function in the gateway, 1.1, 1.1
    gateway support for, description, 1.2
    IMS enabled, 1.3
    mapping parameters using pg4tcpmap tool, 7.6
    mapping SNA parameters to TCP/IP, 6.1
    non-persistent socket transaction type, 1.12.1
    OLTP in gateway architecture, 1.5
    persistent socket transaction type, 1.12.1
    PGAU DEFINE TRANSACTION command, 3.2.5
    remote host languages supported, 3.2.1
    remote transaction initiation, 1.8.1.1
    remote transaction termination, 1.8.1.3
    SENDs and RECEIVEs
      TIP CALL correspondence, 7.3.2
    setting initsid.ora parameters, 6.4
    simple communication
      between gateway and integrating server, 1.13
    steps to communication between server and IMS, 1.13.2
    steps to writing a TIP, 1.14.1
    supports only IMS as OLTP, 1.2, 1.3
    TIP granting privileges needed, 7.9
    TIP internals, F
    trace output files, 8.10.2
    TRANSACTION correspondence, 7.3.3
    transaction types, 1.12.1
  terminal-oriented transactions
    modifying, 4.12
  terminating a TIP conversation, 4.8.1, 7.5.1
  terms, gateway terms defined, 1.3
  tg4pwd utility
    definition, 1.3
    recommended security utility feature, 1.3
  TIP, 1.4, 4.1, 7.1
    also called PL/SQL package
    APPC conversation sharing, 4.10.1, 4.10.3
    background references, F.1
    CALL correspondence, 4.6.2
      on gateway using SNA, 4.6.2
      on gateway using TCP/IP, 7.3.2, 7.3.2
      order restrictions, 4.6.2.2
    calling
      from the client application, 4.7, 7.4
    calling and controlling
      on gateway using SNA, 4.1
      on gateway using TCP/IP, 7, 7.1
    client application development
      content and purpose on gateway using SNA, 4.3.1
      content and purpose on gateway using TCP/IP, 7.2.1
    compiling, 3.4
    content documentation (tipname.doc), 3.5, 3.5
    content file sections
      GENERATION Status, 3.5
      TIP Default Calls, 3.5
      TIP Transaction, 3.5
      TIP User Calls, 3.5
      TIP User Declarations, 3.5
      TIP User Variables, 3.5
    control file, 2.1
    controlling
      runtime conversion warnings, 8.7.2
      runtime data conversion tracing, 8.7.4
      runtime function tracing, 8.7.3
      runtime gateway exchange tracing, 8.7.5
    conversation sharing used to circumvent large TIPs, 4.10.4
    conversion, 1.2, 4.11, 7.8
    converting PL/SQL datatypes to RAW, 1.8.1.2
    creating, 3
    custom TIP writing, F
    customized interface for each remote host transaction (RTP), 4.4
    DATA correspondence, 4.6.1
      on gateway using TCP/IP, 7.3.1
    datatype conversion support for COBOL, D.2
    declaring variables to create a TIP, 4.7.1, 7.4.1
    defining and generating, 3.3
    defining, with PGAU, 2.5
    definition, 1.3, 1.3
    definition errors, 8.1
    dependent TIP body or specification changes, F.2.2
    diagnostic parameters, 4.10.6
    driver procedures
      on gateway using SNA, 1.11.1
      on gateway using TCP/IP, 1.14.1
    flexible call sequence, 4.6.2.1
    four steps to generate
      on gateway using SNA, 1.11
      on gateway using TCP/IP, 1.14
    functions, 1.7
      in Oracle integrating server, 1.8.1.2
    generated by PGAU, 4.1
    granting privileges to use, 3.1, 4.13, 7.9
    independent TIP body changes, F.2.1
    initializations, 4.7.2.2, 7.4.2.2
      overriding, 4.7.2.2, 7.4.2.2
    initializing the conversation, 4.7.2, 7.4.2
    internals, F
    output, sample, G.11
    override parameters, 4.10.6
    overriding default attributes, 4.7.2.2, 7.4.2.2
    overview, 1.11, 1.14
    privileges needed, 3.1, 4.13
    public functions
      tip_init, 4.3.2.2
      tip_inqr, 4.3.2.2
      tip_mode, 4.3.2.2
      tip_term, 4.3.2.2
      tip_updt, 4.3.2.2
    recompiling, F.2, F.2.1, F.2.2
    remote transaction
      correspondence, 4.6
    remote transaction correspondence, on gateway using TCP/IP, 7.3
    remote transaction initiation (PGAINIT), 1.8.1.1, 1.8.1.1
    requirements for corresponding with RHT
      on gateway using SNA, 4.6
      on gateway using TCP/IP, 7.3
    requirements of the client application, 4.5
    service, 4.10.1
    specification file, 3.3
      on gateway using SNA, 1.11.1
      on gateway using TCP/IP, 1.14.1
    specifications
      generated by PGAU, 1.7, 1.7
    steps to writing
      on gateway using SNA, 1.11.1
      on gateway using TCP/IP, 1.14.1
    terminating the conversation, 4.8.1, 7.5.1
    trace controls, 8.7
    trace output sample, G.10
    tracing, 8.5
    TRANSACTION correspondence, 4.6.3, 7.3.3
      on gateway using SNA, 4.6.3
    using transaction instance parameter
      on gateway using TCP/IP, 7.4.2.1
    writing
      on gateway using SNA, 1.11
      on gateway using TCP/IP, 3.2.5
  TIP control file commands, 1.11.1, 1.11.1, 1.11.1, 1.11.1, 1.11.1
  TIP specification, 4.1, F.2, F.2.1
    changes, F.2.2
    errors, F.2.2.1
  TIP warnings and tracing
    suppressing, 8.8
  tipname.doc file, 3.5, 4.5, 4.7.1, 7.4.1
  tipname.pkb file, 8.6
  tname.ctl file, 3.2.7, 3.2.7
  TP_NAME, 5.6.2
  trace option, 8
    TIP definition errors, 8.1
  trace output files
    for gateway using SNA, 8.10.1
    for gateway using TCP/IP, 8.10.2
  TRACE_LEVEL, 8.9.1
  traces, 8.7.2, 8.7.3, 8.7.4, 8.7.5
    diagnostic, 8.5
    enable gateway server trace, 8.9.2
    enabling APPC trace from PL/SQL, 8.9.2.2
    enabling through initsid.ora, 8.9.2.1
    gateway server, 8.9
    purpose of initializing conversations, 4.7.2, 7.4.2
    runtime, 8.6
      trace controls, 8.7
    sample gateway server output, 8.10
    suppressing, 8.8
    TIP, 8.6, 8.8
  TRANSACTION correspondence
    on gateway using SNA, 4.6.3
    on gateway using TCP/IP, 7.3.3
  transaction instance parameter
    on gateway using SNA, 4.7.2.1
    on gateway using TCP/IP, 7.4.2.1
  Transaction Interface Package
    See TIP
  transaction socket
    transaction type for TCP/IP, 1.12.1
  TRANSACTION tname, 2.6.4
  transaction types
    one-shot, persistent and multi-conversational, for SNA, 1.9.1
  TRANSLATE function, C.1.15
  TRANSLITERATE function, C.1.16
  transparency
    (application), 1.2
    (location), on gateway using SNA, 1.2

## U

  UNDEFINE statement, 3.2.7, G.7
  USAGE(ASIS), D.2.2
  USAGE(PASS), D.2.1
    datatype conversion, D.2.1
      FILLER, D.2.1
      PIC 9, D.2.1
      PIC G, D.2.1
    format conversion
      OCCURS DEPENDING ON, D.2.1
      OCCURS n TIMES, D.2.1
  USAGE(SKIP), D.2.3
  utility
    tg4pwd, 1.3
  UTL_PG
    input parameters
      wmsgbsiz, C.2.1.1
    output parameters
      wmsgblk, C.2.1.2
    package
      definition, 1.3
    parameters (input and output), C.2.1
    PL/SQL package, 3.1
  UTL_PG function, C.2
    MAKE_NUMBER_TO_RAW_FORMAT, C.2.5
    MAKE_RAW_TO_NUMBER_FORMAT, C.2.4
    NUMBER_TO_RAW, C.2.3
    NUMBER_TO_RAW and RAW_TO_NUMBER argument values, C.3
    NUMBER_TO_RAW_FORMAT, C.2.7
    RAW_TO_NUMBER, C.2.2
    RAW_TO_NUMBER_FORMAT, C.2.6
    WMSG, C.2.9
    WMSGCNT, C.2.8
  UTL_PG input parameters
    compname, C.2.1.1
    compopts, C.2.1.1
    envrnmnt, C.2.1.1
    mask, C.2.1.1
    maskopts, C.2.1.1
    nlslang, C.2.1.1
    wind, C.2.1.1
  UTL_RAW function
    BIT_AND, C.1.1
    BIT_COMPLEMENT, C.1.2
    BIT_OR, C.1.3
    BIT_XOR, C.1.4
    CAST_TO_RAW, C.1.5
    CAST_TO_VARCHAR2, C.1.6
    COMPARE, C.1.7
    CONCAT, C.1.8
    CONVERT, C.1.9
    COPIES, C.1.10
    LENGTH, C.1.11
    OVERLAY, C.1.12
    REVERSE, C.1.13
    SUBSTR, C.1.14
    TRANSLATE, C.1.15
    TRANSLITERATE, C.1.16
    XRANGE, C.1.17
  UTL_RAW PL/SQL package, 3.1, C
    definition, 1.3
    functions, C.1

## V

  VARIABLE command, 2.6.22

## W

  WMSG function, C.2.9
  WMSGCNT function, C.2.8
  writing PGAU statements, 3.2.6

## X

  XRANGE function, C.1.17